UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmRQ4C4PW4/TffTjrPox22UgF/67ib7vV77o5GBCSrA='
WHERE
key_id = 'a96fcb1466ec045d11532083e53f030340f4fd5fa33c08a9a8550a46d75de317'
AND (
token = 'XmRQ4C4PW4/TffTjrPox22UgF/67ib7vV77o5GBCSrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)