UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vSttJENd331s5oDpqkJ8NVAMpIZDenyKVLIE3wBAlr4='
WHERE
key_id = 'd0396dbd8a08c4af504e1450ed8b3e69e1804761f57bd32d26f29f6b3a39d0dc'
AND (
token = 'vSttJENd331s5oDpqkJ8NVAMpIZDenyKVLIE3wBAlr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)