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