UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fiyxqv4mmSsL6cla8vtBzXtnyIukVe5yOpGvcIFqK8='
WHERE
key_id = '505422aeabe4edb0c97fe41a8444233ac45fbf6ee2505ef04bca48761b7b0630'
AND (
token = '0fiyxqv4mmSsL6cla8vtBzXtnyIukVe5yOpGvcIFqK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)