UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9AMXYGJcw0fnhSDprtk0srE8sMfGAniXQZfa/Pv1a4E=' 
WHERE 
  key_id = '48bfd3e22069690ea720334ebfa4d2649dfeb5c14c364cc6889e5c98efdb8e22' 
  AND (
    token = '9AMXYGJcw0fnhSDprtk0srE8sMfGAniXQZfa/Pv1a4E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029