UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Vpn06FArk6aux1lbd0M+Lq3McHbBhNC3A4KfPxMvwE='
WHERE
key_id = 'f3c3f723086c20e0a462a9ecda12b81968627e7a9b20f8421ff74b316cef07ae'
AND (
token = '6Vpn06FArk6aux1lbd0M+Lq3McHbBhNC3A4KfPxMvwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)