UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't//xecfosb/5O8q4YHLNYJ5ecGpaDfYJmIwGmzizN2w='
WHERE
key_id = 'e7d0c693c0c30ace66e0171a60b393130853ee4a76f54aebb11ea9fb6a4445ea'
AND (
token = 't//xecfosb/5O8q4YHLNYJ5ecGpaDfYJmIwGmzizN2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)