UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '00JXZb91w1EaAt4LQatO/GIXoByz5qkvlB2ixOOI4yE=' 
WHERE 
  key_id = '8546aab37df4df89811a398b020d6e926f4e7e551b3597b5f0f1268f498a613e' 
  AND (
    token = '00JXZb91w1EaAt4LQatO/GIXoByz5qkvlB2ixOOI4yE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045