UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nZ0/02w6nLswsrbKoWRViXLfyaBLCJbG7mG8oh3uCU='
WHERE
key_id = '6872298c673c1347e7c6cce0099c35e047525a4d4f1e4b9fb40f47e225a39a77'
AND (
token = '0nZ0/02w6nLswsrbKoWRViXLfyaBLCJbG7mG8oh3uCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)