UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sA+7P2NbDsVxe3b6Dlg6C+p2sI5s5V0pMmEMaEy+6As='
WHERE
key_id = '39460f5e7c0eec2e1edb1a61e512f865b48c7e70eb2850cb327aab3a211095ae'
AND (
token = 'sA+7P2NbDsVxe3b6Dlg6C+p2sI5s5V0pMmEMaEy+6As='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)