UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xNh9o+Ts9r9mLful3D6FfLH8oY1PIaqcqJZBfkRxBM='
WHERE
key_id = 'bfef052c18e879a0ddbc58333f727a5a2bf7483e47854cbf2de0ce23669d452e'
AND (
token = '7xNh9o+Ts9r9mLful3D6FfLH8oY1PIaqcqJZBfkRxBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)