UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XUK6s/9hAXPObuJRUtkWG1/RQ/xdHvpLGPrpA4+xIjk='
WHERE
key_id = 'a4603fba81db2e9c816b9a6f1dfb1e2f339084c27e7f435afd77e9aa65fca31b'
AND (
token = 'XUK6s/9hAXPObuJRUtkWG1/RQ/xdHvpLGPrpA4+xIjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)