UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7PiJUSTb2Vz/17CgDym2tUWH0BKkJxqF+iHoottsKU='
WHERE
key_id = '071367ccd296b59e51613e649f43460bda80313f0ef18fdc0e79c293c99d2c2f'
AND (
token = 'G7PiJUSTb2Vz/17CgDym2tUWH0BKkJxqF+iHoottsKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)