UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lg30XWFy+RmZ3qHN9HiuYfFf6x9aeaPFuwsRjyUgOWs='
WHERE
key_id = 'bbc56daa543c021a44e13c36e1e6016343572501abff953e1c20dd87ca0509c6'
AND (
token = 'lg30XWFy+RmZ3qHN9HiuYfFf6x9aeaPFuwsRjyUgOWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)