UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n7sKu5ZMJsYH+dH1mWPAB6MmAyNCqV7lLXGhxrv2Uw8='
WHERE
key_id = 'f0f214f8e684f185829bfeb2f90eb6c2f41b94be8bcee812b64254544ddc4c3b'
AND (
token = 'n7sKu5ZMJsYH+dH1mWPAB6MmAyNCqV7lLXGhxrv2Uw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)