SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'edc1ae7a2d087a64a238c4f9d1ae55bdaea3f227b7f79e993b951a2294664613' 
  AND token = 'kd/S0Q+9AxtiUsSmFKmV0rLdwh+0AWVqAL7PfW2FSgA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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