UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a5ctVzNWICkaMJB7vO6YwIPb/ZNoLELb4V6+iY47hms='
WHERE
key_id = 'a5eddb76dedf7fff70206a6193e23510bf14133661ebf9cfe854967ed010d7ea'
AND (
token = 'a5ctVzNWICkaMJB7vO6YwIPb/ZNoLELb4V6+iY47hms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)