UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVXWZro1vCsk+GFWfUdWYNF4gx3dTHNKoayd2MFOOt8='
WHERE
key_id = '7f92f746f30333346c3b2091d3851d5d424aad17baf8ec26fc426d6a2e39c631'
AND (
token = 'XVXWZro1vCsk+GFWfUdWYNF4gx3dTHNKoayd2MFOOt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)