UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8/SUgH4sdRzHOU34+aq6HM1sz3SlEB8F27zER0VEyM='
WHERE
key_id = 'd9aa85937bfd8071d711c45f6ab31d10334b95457ccb805baf8a2f4d08ef9232'
AND (
token = 'P8/SUgH4sdRzHOU34+aq6HM1sz3SlEB8F27zER0VEyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)