UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bxex9OE7D7tGVDHOZT0gECeQii591OwEcH/VZgzgeAg='
WHERE
key_id = 'a09e7df0331f609b140a093f3dfdff80f4dcf1253e70d4399f32a19118a54ef1'
AND (
token = 'bxex9OE7D7tGVDHOZT0gECeQii591OwEcH/VZgzgeAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)