UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YGPdqkc8MQijxbedN/8fNO7AygoTcGqBIHtt5NMyILM='
WHERE
key_id = 'bd1e6289f88aa0a94c49428f102e02f2e65c793c2f1304df9e17b2600a6b60c3'
AND (
token = 'YGPdqkc8MQijxbedN/8fNO7AygoTcGqBIHtt5NMyILM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)