UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fzNSCerfvm8sHn4aWH2n5lePi8ZhxzIHA3z0/eRIRiE='
WHERE
key_id = '8a9e89e96dfffedd246816ba52b9a58235f42db381deae7112d048aa4ee699a1'
AND (
token = 'fzNSCerfvm8sHn4aWH2n5lePi8ZhxzIHA3z0/eRIRiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)