UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bODVkYwgv14NSRM1WyYznqlQjjmrSwwt7PENUoXrt1Y='
WHERE
key_id = '9a2571e717b0ce5fb7335074c1d21bbedd8c01ae4af57c864265c19e159188ed'
AND (
token = 'bODVkYwgv14NSRM1WyYznqlQjjmrSwwt7PENUoXrt1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)