SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd1dd29e8cac504461ca7fecd668a58723e8d02f3c478a5032a836c60b2f89906' 
  AND token = '09mLmwqMaLfcQ0f7g4HY1Rh0LHDK2KlXooly7z2S3RU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}