SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '58505133edd90085d9044b89bdcc80d7e7b7368d27982f32c1bf21032e8bb6be' 
  AND token = '138WlrONrtp0C02sCbr7cwt+8pUA5yUYojwL8myxFHc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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