UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THWDCaryNOWd3NaiPpzqP8U3XKZdgegBEmjHcMyf0gU='
WHERE
key_id = '124f66c1f58cbc9542b0020126657c839ae020d1103a5630caa47f6a378dae3a'
AND (
token = 'THWDCaryNOWd3NaiPpzqP8U3XKZdgegBEmjHcMyf0gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)