SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c2b36dbfea2cb300139072945c136762fd33f8461ee1ae4fc07e64fd899c9222' 
  AND token = '1nF1RjW6fBt29su+0NQm9TpDixv36V1vKBlIGn7MtYo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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