UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tEx6J2ItAsnkLoAkV421fEb4vhTyJFO++CsSPljPkgY='
WHERE
key_id = 'f9bc10b1ba6ee5170cd800b7e356c4fbeadbee4fbe06d1238a35f3e9373dcc66'
AND (
token = 'tEx6J2ItAsnkLoAkV421fEb4vhTyJFO++CsSPljPkgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)