UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dMplAe8y8k3iZOE/tNvOvXlUF7UwmHnEBmNOIhaJafw='
WHERE
key_id = '57ba5239696c5d6ce4308a5116e3cfaa157b81a54d0b006bf501eafe80394746'
AND (
token = 'dMplAe8y8k3iZOE/tNvOvXlUF7UwmHnEBmNOIhaJafw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)