UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XM6TQIrWeGDKOHd02nHAJLc3f4qKAmcB3uYMpii57b0='
WHERE
key_id = '4167ec19d3dee221eb36207c444f81d60f13804a8b0d717b682c421c77249419'
AND (
token = 'XM6TQIrWeGDKOHd02nHAJLc3f4qKAmcB3uYMpii57b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)