UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wBipFB0+ZpYGLHRqE3ptRKHMqyvezhTBZOqRfPp6VsE='
WHERE
key_id = 'af7a49c5d7b6d8571fc87643d58c333a6c44c9aee02eaec6b3c91755cd3453b6'
AND (
token = 'wBipFB0+ZpYGLHRqE3ptRKHMqyvezhTBZOqRfPp6VsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)