UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+4mLHm8JP2p/kqhUMz9SuO9L2kCJpmZk2il5yKqBZK0=' 
WHERE 
  key_id = '82795fb25f8028926e5f01318c31a6f23395689cfdfd1a5b0ca4c81a59cae5bb' 
  AND (
    token = '+4mLHm8JP2p/kqhUMz9SuO9L2kCJpmZk2il5yKqBZK0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025