UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8br70AQEAQZHBvk68lHIeHMMy1kn1o+o7m3beQWq2n0='
WHERE
key_id = 'b7ef6b064a1e992212058d472fe7bc1c20729266b6720f6202302586174b17c1'
AND (
token = '8br70AQEAQZHBvk68lHIeHMMy1kn1o+o7m3beQWq2n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)