SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5f3d5cf9f9f1ae518d42bc115cfc23c067131a8de6a2fde1a4811990c3a535b4' 
  AND token = '4vsAzxhZEpAqEY9c6lb8Fj2tcM0AZpGZ2MNjyoCluuw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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