UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XV1y9AwU5WlCly0DhDFb9cEWyvu/vvWRHXZCm47w/s0='
WHERE
key_id = '209b63cc8f216acc5577bd66314aaeb56c8fd08ee562d1f0278af3b09895a177'
AND (
token = 'XV1y9AwU5WlCly0DhDFb9cEWyvu/vvWRHXZCm47w/s0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)