SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '167e0e0a6af554d21562b0dec45f63c8f155f6ff9a68d915e4b90e2b84f1cc52' 
  AND token = 'yyb12KLbnhGQ3vcTsUr4I1dKHiFhPHKHd6va75kN6Tc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00014

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}