UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lNM5LUaoy3PWrSHN193KUUP45slTDPsIlPH9AsgahqM='
WHERE
key_id = 'd1c274141b44a901896e0fa212e5b1f73f0871c8a7939c843740d0490dd5ed78'
AND (
token = 'lNM5LUaoy3PWrSHN193KUUP45slTDPsIlPH9AsgahqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)