UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aMHZQ7iUpDyI9bG81J32/DgoSk06sO33IfMdzO6SFqo='
WHERE
key_id = '0df65296c0ebca217555768675f2e87bd753fad20cf84cc216ea6842a46b3997'
AND (
token = 'aMHZQ7iUpDyI9bG81J32/DgoSk06sO33IfMdzO6SFqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)