UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's8tCFvl/ibyKLdLA9Q0tL2Bb2O6y/Rkk2jn+7Sq/slQ='
WHERE
key_id = 'b1630844d3783b2fefa67ba8055521cc092349444808631f4829eaecf5f7c624'
AND (
token = 's8tCFvl/ibyKLdLA9Q0tL2Bb2O6y/Rkk2jn+7Sq/slQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)