UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfcsaQODot56nO3xJiOt6cuz/WFBzwpsqQQfwhqn8Ug='
WHERE
key_id = 'c3f3ce6d49a1ff39942cd5378405fe621d961d720410971519ba22295228b85e'
AND (
token = 'ZfcsaQODot56nO3xJiOt6cuz/WFBzwpsqQQfwhqn8Ug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)