UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ILc6aWJkuMX2YSAX7dpJfTnIkGlB3HezZx8ZQ4uEiI='
WHERE
key_id = '392b092c84926a7e346c6033f30ec536d3e3889935e7cb011db9b4c1b0169dc5'
AND (
token = '1ILc6aWJkuMX2YSAX7dpJfTnIkGlB3HezZx8ZQ4uEiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)