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